www.gusucode.com > WSTMall PHP网店系统 v1.6.0PHP源码程序 > WSTMall PHP网店系统 v1.6.0/wstmall_v1.6.0_160506/wstmall_v1.6.0_160506/Apps/Admin/Model/BrandsModel.class.php
<?php namespace Admin\Model; /** * ============================================================================ * WSTMall开源商城 * 官网地址:http://www.wstmall.com * 联系QQ:707563272 * ============================================================================ * 品牌服务类 */ class BrandsModel extends BaseModel { /** * 新增 */ public function insert(){ $rd = array('status'=>-1); $id = (int)I("id",0); $idsStr = WSTFormatIn(",", I("catIds")); $ids = array(); if($idsStr!=''){ $idsStr = explode(',',$idsStr); foreach ($idsStr as $key =>$v){ if((int)$v>0)$ids[] = (int)$v; } } $data = array(); $data["brandName"] = I("brandName"); $data["brandIco"] = I("brandIco"); $data["brandDesc"] = I("brandDesc"); $data["createTime"] = date('Y-m-d H:i:s'); $data["brandFlag"] = 1; if($this->checkEmpty($data) && count($ids)>0){ $rs = $this->add($data); if(false !== $rs){ $m = M('goods_cat_brands'); foreach ($ids as $key =>$v){ $d = array(); $d['catId'] = $v; $d['brandId'] = $rs; $m->add($d); } $rd['status']= 1; } } return $rd; } /** * 修改 */ public function edit(){ $rd = array('status'=>-1); $id = (int)I("id",0); $idsStr = WSTFormatIn(",", I("catIds")); $ids = array(); if($idsStr!=''){ $idsStr = explode(',',$idsStr); foreach ($idsStr as $key =>$v){ if((int)$v>0)$ids[] = (int)$v; } } $filter = array(); //获取品牌的关联分类 $sql = "select catId from __PREFIX__goods_cat_brands where brandId=".$id; $catBrands = $this->query($sql); foreach ($catBrands as $key =>$v){ if(!in_array($v['catId'],$ids))$filter[] = $v['catId']; } //查询指定的分类下是否有品牌被引用了 if(count($filter)>0){ $sql = "select count(*) counts from __PREFIX__goods where brandId =".$id." and goodsCatId1 in(".implode(',',$filter).") and goodsFlag=1 "; $grs = $this->queryRow($sql); if($grs['counts']>0){ $rd['status'] = -2; return $rd; } } $this->brandName = I("brandName"); $this->brandIco = I("brandIco"); $this->brandDesc = I("brandDesc"); if($this->checkEmpty($data) && count($ids)>0){ $rs = $this->where("brandId=".$id)->save(); if(false !== $rs){ $cm = M('goods_cat_brands'); $cm->where('brandId='.$id)->delete(); foreach ($ids as $key =>$v){ $d = array(); $d['catId'] = $v; $d['brandId'] = $id; $cm->add($d); } $rd['status']= 1; } } return $rd; } /** * 获取指定对象 */ public function get(){ $rs = $this->where("brandId=".(int)I('id'))->find(); //获取关联的分类 $sql = "select * from __PREFIX__goods_cat_brands where brandId=".(int)I('id'); $catBrands = $this->query($sql); if(!empty($catBrands)){ foreach ($catBrands as $key => $v){ $rs['catBrands_'.$v['catId']] = 1; } } return $rs; } /** * 分页列表 */ public function queryByPage(){ $brandName = WSTAddslashes(I("brandName")); $catId = (int)I("catId"); $sql = "select b.* from __PREFIX__brands b"; if($catId>0){ $sql .= ", __PREFIX__goods_cat_brands cb"; } $sql .= " where brandFlag=1"; if($catId>0){ $sql .= " and b.brandId = cb.brandId and cb.catId = $catId"; } if($brandName!=""){ $sql .= " and brandName like '%".$brandName."%'"; } $sql .= " order by b.brandId desc"; return $this->pageQuery($sql); } /** * 获取列表 */ public function queryByList(){ return $this->where('brandFlag=1')->select(); } /** * 删除 */ public function del(){ $rd = array('status'=>-1); if(I('id',0)==0)return $rd; $this->brandFlag = -1; $rs = $this->where("brandId=".(int)I('id',0))->save(); if(false !== $rs){ $rd['status']= 1; } return $rd; } }; ?>